<?php

/**
 * Subclass for representing a row from the 'ghv_member' table.
 *
 * 
 *
 * @package lib.model
 */ 
class GhvMember extends BaseGhvMember
{
	public static function getlist()
	{
		$con =  new MysqlDAL('propel');
		$sql = "SELECT u.id, u.username, u.phone, u.created_datetime,m.id AS gid 
				FROM user AS u INNER JOIN ghv_member AS m 
				ON u.id = m.user_id 
				ORDER BY m.id ASC ";
		return $con->doselect($sql);
	}
}
